#导出数据
clickhouse-client -h 172.18.32.241 --port 9000 -u default --password jinZhou7766 -m -n --query "select * from venusTest.test_type format CSV" > /data/select.csv
#导入数据
clickhouse-client -h 172.18.32.241 --port 9000 -u default --password jinZhou7766 -m -n  --query "insert into venusTest.test_type format CSV" < select.csv


clickhouse client -h 172.18.38.123 --port 9000 -udefault --password jinZhou7766 --database="jin_zhou" --query="INSERT INTO device_log FORMAT JSONEachRow" < 20220214185017.607557.json

clickhouse-client -h 172.18.38.123 --port 9000 -u default --password jinZhou7766 -m -n --query "select * from jin_zhou.device_log where partition_date ='2022-04-16' format JSONEachRow" > /opt/dataTransfer/dataStore/20220416.csv